
DROP TABLE job_base_content
go

CREATE TABLE job_base_content (
       content_id           int IDENTITY(1000,1),
       title                varchar(100) NULL,
       description          varchar(200) NULL,
       status_id            int NULL,
       subject_id           int NULL,
       order_no               int NULL,
       content              image NULL,
       count                int NULL,
       last_update_time     datetime NULL,
       last_update_user     varchar(20) NULL
)
go


ALTER TABLE job_base_content
       ADD PRIMARY KEY (content_id)
go


DROP TABLE job_hunter
go

CREATE TABLE job_hunter (
       job_id               int IDENTITY,
       job_no               varchar(20) NULL,
       name                 varchar(100) NULL,
       industry             varchar(100) NULL,
       salary               varchar(50) NULL,
       office_address       varchar(40) NULL,
       responsibility       varchar(600) NULL,
       grade                varchar(600) NULL,
       contact_name         varchar(20) NULL,
       email                varchar(30) NULL,
       contact_tel          varchar(30) NULL,
       creator              varchar(20) NULL,
       create_date          datetime NULL,
       low_education        int NULL,
       least_year           int NULL
)
go


ALTER TABLE job_hunter
       ADD PRIMARY KEY (job_id)
go


DROP TABLE job_user
go

CREATE TABLE job_user (
       user_id              int IDENTITY,
       login_name           varchar(20) NULL,
       name                 varchar(20) NULL,
       password             varchar(20) NULL,
       permissions          varchar(100) NULL,
       email                varchar(30) NULL,
       view_jober           int NULL,
       view_education_level int NULL,
       user_type            int NULL
)
go


ALTER TABLE job_user
       ADD PRIMARY KEY (user_id)
go



